﻿CREATE TYPE [dbo].[udtContactsPrincipals] AS TABLE (
    [ContactID]      INT           NOT NULL,
    [PrincipalID]    INT           NOT NULL,
    [FunctionKey]    INT           NULL,
    [JobtitleKey]    INT           NULL,
    [PhoneExtension] NVARCHAR (50) NULL,
    [Fax]            NVARCHAR (50) NULL,
    [Job]            NVARCHAR (50) NULL,
    PRIMARY KEY CLUSTERED ([ContactID] ASC, [PrincipalID] ASC));

